CREATE TABLE [dbo].[PurchSales]
(
[Security Name/Description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fund ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Local Currency] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Transaction Type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Shares/Par] [float] NULL,
[Price (Base)] [float] NULL,
[Net Amount (Base)] [float] NULL,
[ID Cost Base - Buy Lot] [float] NULL,
[Trade Date] [datetime] NULL,
[Contractual Settle Date] [datetime] NULL,
[Settlement Currency] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Settlement Location] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Settlement Status] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Broker] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Broker Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Segregated Lot] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Closing Date] [datetime] NULL,
[Last Closing Date] [datetime] NULL,
[Free to Distribute Date] [datetime] NULL,
[Contributing ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Closing Price] [float] NULL,
[Investor] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Base Currency Code] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Lot Number] [float] NULL,
[Account Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset ID2] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SSC Trade ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cancel Post Date] [datetime] NULL,
[Cancel Report Date] [datetime] NULL,
[Cancel Trade ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Canceled] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'VirtualFolder', N'SSB Stuff', 'SCHEMA', N'dbo', 'TABLE', N'PurchSales', NULL, NULL
GO
